============================================================================== Simba Concur ODBC Data Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Concur ODBC Connector 1.7.8, as well as the version history. 1.7.8 ======================================================================== Released 2024-06-27 Enhancements & New Features * [MPH-16271] Updated Ubuntu support The connector now supports Ubuntu 24.04 version. For a list of supported platform versions, see the Installation and Configuration Guide. * Update on database schemas No new database schema are added, modified and decommissioned. Resolved Issues The following issue has been resolved in Simba Concur ODBC Connector 1.7.8. * [MPH-16518] Due to security issues, memory leaks and corruption are caused. Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application. * Some updates may fail when double-buffering is enabled. To avoid this issue, it is recommended that you set the EnableDoubleBuffer connection property to 0. * On Windows, the connector cannot use the EncAccessToken setting if the Auth_AccessToken string value exists in the registry key for the DSN. If the Auth_AccessToken string value exists in the DSN registry key, the connector cannot authenticate the connection using the EncAccessToken setting. This issue occurs even if there is no value data specified in Auth_AccessToken. As a workaround, delete the Auth_AccessToken string value from your DSN registry key if you want to use the EncAccessToken setting for authentication * In some cases, if you query data while the EncryptSwapFile property is set to 1, the connector might return a corrupted result set. When this issue occurs, the returned result set is corrupted, but the original data in the data store is not affected. As a potential workaround, do either of the following: - Disable swap file creation by setting the MemoryManagerStrategy property to 1. However, be aware that while this setting prevents the connector from returning corrupted result sets, it may also cause some SQL operations on non-SQL data to return out-of-memory errors. - If your query does not involve sensitive data, set the EncryptSwapFile property to 0 before running the query. However, be aware that when swap file encryption is disabled, any data that the connector caches in order to support the query is written in plain text. For more information about the swap file and memory manager features, see the Installation and Configuration Guide. * In some cases, a request may fail and return a JSON parsing error. This issue occurs because the server sometimes sends an incomplete response. * On Windows, the connector cannot use the EncAccessToken setting if the Auth_AccessToken string value exists in the registry key for the DSN. If the Auth_AccessToken string value exists in the DSN registry key, the connector cannot authenticate the connection using the EncAccessToken setting. This issue occurs even if there is no value data specified in Auth_AccessToken. As a workaround, delete the Auth_AccessToken string value from your DSN registry key if you want to use the EncAccessToken setting for authentication. * Reusing a prepared statement handle may cause a memory leak. If a prepared statement handle is used more than once, a memory leak may occur. Workflow Changes ============================================================= The following changes may disrupt established workflows for the connector. 1.7.8 ------------------------------------------------------------------------ * [MPH-16291][MPH-15226] Removed support for multiple operating systems Beginning with this release, the connector no longer supports the following operating systems: - Windows Server 2012r2 - macOS 10.15 - CentOS 7 - Debian 9 and 10 - RHEL 7 For a list of supported operating systems, see the Installation and Configuration Guide. 1.7.6 ------------------------------------------------------------------------ * Removed support for Visual Studio 2015 Beginning with this release, support for Visual C++ Redistributable for Visual Studio 2015 has been removed. For supported versions, see the Installation and Configuration Guide. * Removed support for Windows operating system Beginning with this release, the connector no longer supports Windows 8.1 operating system. For a list of supported operating systems, see the Installation and Configuration Guide. 1.6.19 ----------------------------------------------------------------------- * Support for old authentication Beginning with this release, the driver supports the pre-2017 Concur credentials authentication. As a result, the Auth_Expires connection property is also supported. 1.6.18 ----------------------------------------------------------------------- * Support for Concur credentials authentication removed Beginning with this release, the driver no longer supports the pre-2017 Concur credentials authentication. As a result, the Auth_Expires connection property is no longer used. * Quick_Expenses schema table removed Beginning with this release, the Quick_Expenses schema table is no longer supported. * Support for Trips-related tables removed Beginning with this release, tables related to the Trips schema table are no longer able to retrieve data. Version History ============================================================== 1.7.7 ------------------------------------------------------------------------ Released 2024-04-12 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - Expat 2.6.2 (previously 2.6.0) - libcURL 8.7.1 (previously 8.6.0) 1.7.6 ------------------------------------------------------------------------ Released 2024-03-22 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - Expat 2.6.0 (previously 2.5.0) - libcURL 8.6.0 (previously 8.4.0) - OpenSSL 3.0.13 (previously 3.0.11) - pcre 10.42 (previously 8.45) - Poco 1.12.5 (previously 1.12.4) - Zlib 1.3.1 (previously 1.2.13) * Updated security The following compiler and linker flags have been used to improve security checks in the connector: - /CETCOMPAT - /Qspectre * Updated Visual Studio support The connector now supports Windows Visual Studio 2022. For supported versions, see the Installation and Configuration Guide. * Updated Windows support The connector now supports Windows 11 and Windows Server versions 2016, 2019, and 2022. For supported Windows versions, see the Installation and Configuration Guide. 1.7.4 ------------------------------------------------------------------------ Released 2023-11-09 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - Expat 2.5.0 (previously 2.4.6) - ICU 71.1.x (previously 58.3.x) - LibCurl 8.4.0 (previously 7.84.0) - OpenSSL 3.0.11 (previously 1.1.1s) - Pcre 8.45 (previously 8.37) - Poco 1.12.4 (previously 1.9.0) - zlib 1.2.13 (previously 1.2.11) * Updated security The following compiler and linker flags have been used to improve security checks in the connector: - /guard:cf - /SDL - ZH:SHA_256 * Updated compiler The connector now uses macOS 11 ARM Xcode 13.2. For this current release, the connector is built using both the new and old (macOS 10_15 Xcode 11_3) compiler versions. ==============================================================================